SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_ShowVerifiedParticipantByRecruitID]
	
	(
	@param_id int 
	
	)
	
AS

	/* SET NOCOUNT ON */
	SELECT JOL_Employer.JOL_Employer_Name,
	JOL_Recruitment_Participants_apply.id,
	JOL_Recruitment_Participants_apply.booth_quantity,
	JOL_Recruitment_Participants_apply.booth_arrange,
	JOL_Recruitment_Participants_apply.remark_recruitment,
	JOL_Recruitment_Participants_apply.[state] 
	  FROM JOL_Employer,JOL_Recruitment_Participants_apply
	WHERE JOL_Recruitment_Participants_apply.recruitment=@param_id 
		AND JOL_Employer.JOL_Employer_No=JOL_Recruitment_Participants_apply.employing_unit 
		and JOL_Recruitment_Participants_apply.state = 1
	RETURN


GO
